Views [dbo].[vChangeLogReport]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created3:38:11 PM Friday, January 07, 2011
Last Modified1:48:32 PM Thursday, September 22, 2011
Columns
Name
ChangeLogKey
ObjectTypeName
ActionType
Description
CreatedDate
PropertyName
OriginalValue
OriginalDescription
CurrentValue
CurrentDescription
UserKey
ContactMaster
UserId
SQL Script
CREATE VIEW [dbo].[vChangeLogReport]
AS
SELECT DISTINCT CL.[ChangeLogKey], CL.[ObjectTypeName], CL.[ActionType], CL.[Description],
                CL.[CreatedOn] AS [CreatedDate], CP.[PropertyName], CP.[OriginalValue],
                CP.[OriginalDescription], CP.[CurrentValue], CP.[CurrentDescription], UM.[UserKey],
                UM.[ContactMaster], UM.[UserId]
  FROM [dbo].[ChangeLog] CL
       INNER JOIN [dbo].[ChangeProperty] CP ON CL.[ChangeLogKey] = CP.[ChangeLogKey]
       INNER JOIN [dbo].[UserMain] UM ON CL.[CreatedByUserKey] = UM.[UserKey]

GO
Uses